import MySQLdb

# connect
db = MySQLdb.connect(host="localhost", user="root", passwd="", db="testdb")

# create a cursor
cursor = db.cursor()

# execute SQL statement
counter = 0
while counter < 100000:
    cursor.execute("insert into person(last_name, first_name) values('test','test')")
    counter = counter + 1
